package kr.or.kosta.otr.service.boardservice;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import kr.or.kosta.otr.utill.BoardListVO;
import kr.or.kosta.otr.vo.BoardVO;
import kr.or.kosta.otr.vo.CommentVO;
import kr.or.kosta.otr.vo.FileVO;

public interface BoardService {
	BoardVO writeBoard(BoardVO bvo, FileVO fvo) throws SQLException;
	void updateBoard(BoardVO bvo, FileVO fvo) throws SQLException;
	void deleteBoard(int boardId) throws SQLException;
	void deleteFile(int boardId) throws SQLException;
	String getOneFileName(int boardId) throws SQLException;
	HashMap<String, Object> getOneBoardById(int boardId) throws SQLException;
	public HashMap<String, Object> getOneBoardRefresh(int boardId) throws SQLException;
	BoardListVO getBoardListByPage(String pageNo) throws SQLException;
	ArrayList<BoardVO> getBoardByUserId(String userId) throws SQLException;
	ArrayList<BoardVO> getBoardByTitle(String title) throws SQLException;
	ArrayList<BoardVO> getBoardByContent(String content) throws SQLException;
	void writeParentComment(CommentVO cvo) throws SQLException;
	void writeChildComment(int parentCommentId, CommentVO cvo) throws SQLException;
	void deleteComment(int CommentId) throws SQLException;
	void updateComment(CommentVO vo) throws SQLException;
}
